<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE topic
  PUBLIC "-//OASIS//DTD DITA Composite//EN" "ditabase.dtd">
<topic id="topic1" xml:lang="en">
  <title id="fp141670">gp_resgroup_config</title>
  <body>
    <p>The <codeph>gp_toolkit.gp_resgroup_config</codeph> view allows administrators to see the
      current CPU, memory, and concurrency limits for a resource group.</p>
      <note>The <codeph>gp_resgroup_config</codeph> view is valid only when resource group-based resource management is active.</note>
    <table id="fp141982">
      <title>gp_toolkit.gp_resgroup_config</title>
      <tgroup cols="4">
        <colspec colnum="1" colname="col1" colwidth="114pt"/>
        <colspec colnum="2" colname="col2" colwidth="66pt"/>
        <colspec colnum="3" colname="col3" colwidth="133.5pt"/>
        <colspec colnum="4" colname="col4" colwidth="147pt"/>
        <thead>
          <row>
            <entry colname="col1">column</entry>
            <entry colname="col2">type</entry>
            <entry colname="col3">references</entry>
            <entry colname="col4">description</entry>
          </row>
        </thead>
        <tbody>
          <row>
            <entry colname="col1">
              <codeph>groupid</codeph>
            </entry>
            <entry colname="col2">oid</entry>
            <entry colname="col3">pg_resgroup.oid</entry>
            <entry colname="col4">The ID of the resource group.</entry>
          </row>
          <row>
            <entry colname="col1">
              <codeph>groupname</codeph>
            </entry>
            <entry colname="col2">name</entry>
            <entry colname="col3">pg_resgroup.rsgname</entry>
            <entry colname="col4">The name of the resource group.</entry>
          </row>
          <row>
            <entry colname="col1">
              <codeph>concurrency</codeph>
            </entry>
            <entry colname="col2">text</entry>
            <entry colname="col3">pg_resgroupcapability.value for pg_resgroupcapability.reslimittype = 1</entry>
            <entry colname="col4">The concurrency (<codeph>CONCURRENCY</codeph>) value specified for the resource group.</entry>
          </row>
          <row>
            <entry colname="col1">
              <codeph>cpu_rate_limit</codeph>
            </entry>
            <entry colname="col2">text</entry>
            <entry colname="col3">pg_resgroupcapability.value for pg_resgroupcapability.reslimittype = 2</entry>
            <entry colname="col4">The CPU limit (<codeph>CPU_RATE_LIMIT</codeph>) value specified for the resource group, or -1.</entry>
          </row>
          <row>
            <entry colname="col1">
              <codeph>memory_limit</codeph>
            </entry>
            <entry colname="col2">text</entry>
            <entry colname="col3">pg_resgroupcapability.value for pg_resgroupcapability.reslimittype = 3</entry>
            <entry colname="col4">The memory limit (<codeph>MEMORY_LIMIT</codeph>) value specified for the resource group.</entry>
          </row>
          <row>
            <entry colname="col1">
              <codeph>memory_shared_quota</codeph>
            </entry>
            <entry colname="col2">text</entry>
            <entry colname="col3">pg_resgroupcapability.value for pg_resgroupcapability.reslimittype = 4</entry>
            <entry colname="col4">The shared memory quota (<codeph>MEMORY_SHARED_QUOTA</codeph>) value specified for the resource group.</entry>
          </row>
          <row>
            <entry colname="col1">
              <codeph>memory_spill_ratio</codeph>
            </entry>
            <entry colname="col2">text</entry>
            <entry colname="col3">pg_resgroupcapability.value for pg_resgroupcapability.reslimittype = 5</entry>
            <entry colname="col4">The memory spill ratio (<codeph>MEMORY_SPILL_RATIO</codeph>) value specified for the resource group.</entry>
          </row>
          <row>
            <entry colname="col1">
              <codeph>memory_auditor</codeph>
            </entry>
            <entry colname="col2">text</entry>
            <entry colname="col3">pg_resgroupcapability.value for pg_resgroupcapability.reslimittype = 6</entry>
            <entry colname="col4">The memory auditor in use for the resource group.</entry>
          </row>
          <row>
            <entry colname="col1">
              <codeph>cpuset</codeph>
            </entry>
            <entry colname="col2">text</entry>
            <entry colname="col3">pg_resgroupcapability.value for pg_resgroupcapability.reslimittype = 7</entry>
            <entry colname="col4">The CPU cores reserved for the resource group, or -1.</entry>
          </row>
        </tbody>
      </tgroup>
    </table>
  </body>
</topic>
